'use strict'

const pg = require('pg')

let psql = new pg.Pool({
    database:'liubangling',
    user:'liubangling',
    port:5432,
    host:'127.0.0.1',
    password:'001223',
    max:5       //最大使用五个客户端连接
})

//括号开头加分号
;(async ()=>{
    let tm = Date.now()
    // 随机字符串转乘16进制并去掉前两位
    let id = `${Math.random().toString(16).substring(2)}`
    let sqltext = `INSERT INTO content(id,detail,title,add_time,update_time) VALUES($1,$2,$3,$4,$5)`
    let r = await psql.query(sqltext,[id,`测试内容:${Math.random()}`,'test',tm,tm])

    console.log(r)

    //关闭连接
    psql.end()
})();